create external table jms_ods.tab_ops_star_ratings_info(
    id bigint  comment '主键id',
    five_start_num bigint  comment '五星人数',
    four_start_num bigint  comment '四星人数',
    one_start_num bigint  comment '一星人数',
    national_mon_five_start_amt bigint comment '全国月度五星金额',
    national_mon_four_start_amt bigint comment '全国月度四星金额',
    area_quarter_first_amt bigint comment '代理区季度第一名',
    area_quarter_second_amt bigint comment '代理区季度第二名',
    area_quarter_third_amt bigint comment '代理区季度第三名',
    national_quarter_top_ten_amt bigint comment '全国季度前十名',
    national_year_first_amt bigint comment '全国年度第一名',
    national_year_second_amt bigint comment '全国年度第二名',
    national_year_third_amt bigint comment '全国年度第三名',
    national_year_fourth_amt bigint comment '全国年度第四名',
    national_year_fifth_amt bigint comment '全国年度第五名',
    total_score string comment '总分值',
    service_attitude_score string comment '服务态度分值',
    trilateral_complaint_score string comment '三方投诉分值',
    sign_complaint_score string comment '签收投诉分值',
    prescription_sign_score string comment '时效签收率分值',
    prescription_sign_full_score string comment '时效签收率满分值',
    prescription_sign_zero_score string comment '时效签收率零分值',
    dispatch_score string comment '派签时长分值',
    dispatch_full_score string comment '派签时长满分值',
    dispatch_zero_score string comment '派签时长零分值',
    throwaway_collect_score string comment '散单揽收成功率分值',
    throwaway_collect_full_score string comment '散单揽收成功率满分值',
    throwaway_collect_zero_score string comment '散单揽收成功率零分值',
    return_cancellat_score string comment '退件上门取件取消率分值',
    return_cancellat_full_score string comment '退件上门取件取消率满分值',
    return_cancellat_zero_score string comment '退件上门取件取消率零分值',
    is_valid bigint comment '是否有效：0-无效，1-有效',
    creator_code string comment '创建者code',
    creator_name string comment '创建者',
    updater_code string comment '更新者code',
    updater_name string comment '更新者',
    update_time timestamp  comment '修改时间',
    create_time timestamp comment '创建时间'
) comment '星级排名配置信息表'
stored as parquet
location '/dw/hive/jms_ods.db/external/tab_ops_star_ratings_info';
